﻿CREATE TABLE [common].[GICS] (
    [Id]                BIGINT          IDENTITY (1, 1) NOT NULL,
    [SectorCode]        NCHAR (2)       NOT NULL,
    [SectorName]        NVARCHAR (128)  NOT NULL,
    [IndustryGroupCode] NCHAR (4)       NOT NULL,
    [IndustryGroupName] NVARCHAR (128)  NOT NULL,
    [IndustryCode]      NCHAR (6)       NOT NULL,
    [IndustryName]      NVARCHAR (128)  NOT NULL,
    [SubIndustryCode]   NCHAR (8)       NOT NULL,
    [SubIndustryName]   NVARCHAR (128)  NOT NULL,
    [Description]       NVARCHAR (4000) DEFAULT ('') NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

